Hệ thống quản lý ISP trong PHP
1 <?php
2 require_once 'includes/header.php';
3 require_once "includes/classes/admin-class.php";
4 $admins = new Admins($dbh);
5 if (!isset($_SESSION['admin_session']) )
6 {
7 $commons->redirectTo(SITE_PATH.'login.php');
8 }
9 ?>
10 <div class="dashboard">
11 <div class="col-md-12 col-sm-12">
12 <div class="col-md-6"><h4><a href="bills.php" class="btn btn-sm btn-primary"> Back</a> Generated bills for Month of October</h4></div>
13 <div class="col-md-6">
14 <form class="form-inline pull-right">
15 <div class="form-group">
16 <label class="sr-only" for="search">Search for</label>
17 <div class="input-group">
18 <div class="input-group-addon"><span class="glyphicon glyphicon-search" aria-hidden="true"></span></div>
19 <input type="text" class="form-control" id="search" placeholder="Type a name">
20 <div class="input-group-addon"></div>
21 </div>
22 </div>
23 </form>
24 <a href="bill_generation.php" class="btn btn-success pull-right">Generate Again</a>
25 </div>
26 <br><br>
27 </div>
28 <div class="col-md-12 col-sm-12" id="bill_table">
29 <table class="table table-striped table-bordered">
30 <thead class="thead-inverse">
31 <tr>
32 <th>ID </th>
33 <th>Name</th>
34 <th>Months</th>
35 <th>Package</th>
36 <th>Amounts</th>
37 <th>Delete</th>
38 </tr>
39 </thead>
40 <tbody>
41 <?php
42 $customers = $admins->fetchActiveCustomers();
43 if (isset($customers) && sizeof($customers) > 0){
44 foreach ($customers as $customer) {
45 $customer_id = $customer->id;
46 $customer_name = $customer->full_name;
47 $package_id = $customer->package_id;
48 $packageInfo = $admins->getPackageInfo($package_id);
49 $amount = $packageInfo->fee;
50 $r_month = date('F');
51 $payments = $admins->getLastMonth($customer_id);
52 if(!empty($payments)){$last_month = $payments->r_month;}
53 if(isset($last_month) && $last_month == $r_month){ ?>
54 <tr>
55 <td scope="row"><?=$customer_id?></td>
56 <td colspan="5">Monthly bill of this month for <b><?=$customer_name?></b> was already generated !</td>
57 </tr>
58 <?php } else {
59 if (!$admins->billGenerate($customer_id, $r_month, $amount))
60 { ?>
61 <tr>
62 <td scope="row"><?=$customer_id?></td>
63 <td colspan="4">Bill genation for <?=$customer_name?> was not successful !</td>
64 <td><button onClick=retry() type="button" class="btn btn-info">Retry</button></td>
65 </tr>
66 <?php
67 }else { ?>
68 <tr>
69 <td scope="row"><?=$customer_id?></td>
70 <td><?=$customer_name?></td>
71 <td><?=$r_month?></td>
72 <td><?=$packageInfo->name?></td>
73 <td><?=$amount?></td>
74 <td><button type="button" onClick=deleteBill() class="btn btn-info">Delete</button> <button onClick=editBill() type="button" class="btn btn-info">Edit</button></td>
75 </tr>
76 <?php }
77 }
78 ?>
79 <?php
80 }
81 } ?>
82 </tbody>
83 </table>
84 </div>
85 </div>
86
87 <?php include 'includes/footer.php'; ?>
88 <script type="text/javascript">
89 document.getElementById('date').valueAsDate = new Date();
90 function pay(id) {
91 let left = (screen.width/2)-(600/2);
92 let top = (screen.height/2)-(800/2);
93 let params = `scrollbars=no,resizable=no,status=no,location=no,toolbar=no,menubar=no,width=600,height=800,left=${left},top=${top}`;
94 open('pay.php?customer='+id, 'Hello World !', params)
95 }
96 function bill(id) {
97 let left = (screen.width/2)-(600/2);
98 let top = (screen.height/2)-(800/2);
99 let params = `scrollbars=no,resizable=no,status=no,location=no,toolbar=no,menubar=no,width=600,height=800,left=${left},top=${top}`;
100 open('bill.php?customer='+id, 'Hello World !', params)
101 }
102 </script>
